SAS Real-Time Decision Manager and SAS^® Decision Services enable you to configure the connections that they keep open to the SAS^® Federation Server. You might need to adjust the settings for this pool of open connections in order to get optimal performance in your environment.

The following seven settings can be adjusted to optimize performance. The values that are suggested below are for an operational environment, which assumes that each node contains: Eight CPUs, one instance of the SAS^® Decision Services Engine Server, and one instance of SAS Federation Server.

1. MaxActive = 12
2. MaxIdle = 16
3. MinIdle = 4
4. MaxTotal = 16
5. MinEvictableIdleTimeMillis = 120000
6. NumTestsPerEvictionRun = 10
7. TimeBetweenEvictionRunsMillis = 120000

Note: For detailed instructions on how to set these values, see SAS Note 49375: "How to set MaxActive and MaxIdle for the DataFlux^® Federation Server connection pool for SAS^® Real-Time Decision Manager."

Do not adjust any other settings for the connection pool. No adjustments are needed for the corresponding settings for the statement pool.

SAS recommends the aggressive eviction settings in the list above in order to minimize memory usage for SAS Federation Server and DS2 code. However, you might find that these eviction settings should be increased in your environment. Settings that are too aggressive trigger frequent restarts of your pool of connections. The connection pool restarts increase average campaign response times significantly.

After your initial adjustment, use the SAS Real-Time Decision Manager tool PoolDiagnostics.jsp to observe system behavior and guide you in increasing or decreasing these values. Check that these settings remain appropriate for your environment whenever you upgrade, install fixes, or change campaign usage patterns.

Operating System and Release Information